DAO

  1. Click the DAO option in the Select Data Source dialog box. This option allows you to connect to a database file through Data Access Objects (DAO).
  2. Select a database type from the Database drop-down list box. This list displays all DAO compatible database drivers installed on your system. Crystal Reports installs many DAO drivers for you. For this example, you can select Access as the database type.
  3. Use the Browse button to open the Select Database File dialog box. Use this dialog box to locate and select a database file. Crystal Reports includes several sample databases in the \Program Files\Seagate Software\Crystal Reports directory by default. You can select the XTREME.MDB Access file from this directory for this example.
  4. Click Open in the Select Database File dialog box, and the path and file name of the database you selected appear in the DAO text box on the Select Data Source dialog box.
  5. Click Next, and the Select Recordset dialog box appears.
  6. If the database requires log on information, specify a user name and password to log on.
  7. Determine if you want to create a Recordset using an object available from your database, such as a database table, or if you prefer to specify a SQL statement. Select the appropriate option in the Recordset section of the Select Recordset dialog box.
  8. If you want to connect to a database object, use the Object Type drop-down list to select the type of database object, such as a Table, then select the object itself from the Object drop-down list.
  9. If you want to obtain a Recordset using a SQL statement, write the SQL statement in the text box provided and click Next.
  10. Click Finish in the Select Recordset dialog box. You will see dao in the list box on the Data Tab of the Standard Report Expert.
  11. Continue creating your report normally. While creating your report, the dao specification will act like a database table, providing all fields that have been obtained from your DAO Recordset.


Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com